package tablesqls

func CreateAdminMenuTableSql() (sql string) {
	sql = `
		CREATE TABLE admin_menu (
		id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
		admin_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
		menu_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT '菜单栏ID',
		created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
		created_user varchar(60) NOT NULL DEFAULT '' COMMENT '创建人',
		PRIMARY KEY (id),
		KEY idx_admin_id (admin_id)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员菜单栏表';
	`

	return
}

func CreateAdminMenuTableDataSql() (sql string) {
	sql = `
		INSERT INTO admin_menu (id, admin_id, menu_id, created_user) VALUES
		 (1, 1, 16, 'init'),
		 (2, 1, 21, 'init'),
		 (3, 1, 20, 'init'),
		 (4, 1, 19, 'init'),
		 (5, 1, 18, 'init'),
		 (6, 1, 17, 'init'),
		 (7, 1, 13, 'init'),
		 (8, 1, 15, 'init'),
		 (9, 1, 14, 'init'),
		 (10, 1, 10, 'init'),
		 (11, 1, 12, 'init'),
		 (12, 1, 11, 'init'),
		 (13, 1, 7, 'init'),
		 (14, 1, 9, 'init'),
		 (15, 1, 8, 'init'),
		 (16, 1, 4, 'init'),
		 (17, 1, 6, 'init'),
		 (18, 1, 5, 'init'),
		 (19, 1, 1, 'init'),
		 (20, 1, 3, 'init'),
		 (21, 1, 2, 'init'),
		 (22, 1, 22, 'init'),
		 (23, 1, 23, 'init'),
		 (24, 1, 24, 'init'),
		 (25, 1, 25, 'init');
		`

	return
}
